package edums.student.dao;

import java.sql.SQLException;
import java.util.List;
import java.util.Map;

import edums.employee.dto.StudentDTO;
import edums.student.dto.GuestBookDTO;

public interface GuestBookDAO {

	public abstract void insertGuestBook(GuestBookDTO gdto) throws SQLException;
	
	public abstract void removeGuestBook(Map guestBookInfo) throws SQLException;

	public abstract int selectGuestBookNo(String studentId) throws SQLException;
	
	public abstract GuestBookDTO selectGuestBookById(Map guestBookInfo) throws SQLException;
	
	public abstract GuestBookDTO selectGuestBookForModifyForm(Map guestBookInfo) throws SQLException;
	
	public abstract void updateGuestBook(GuestBookDTO gdto) throws SQLException;
	
	public abstract List selectAllGuestBook(Map guestBookInfo) throws SQLException;
	
	public abstract int selectGuestBookTotalContent(Map guestBookInfo) throws SQLException;
	
	public abstract List selectGuestBookReplyCount(Map guestBookInfo) throws SQLException;
	
	public abstract List selectGuestBookReply(Map guestBookInfo) throws SQLException;
	
	public abstract int selectReplyRestep(GuestBookDTO gdto) throws SQLException;
	
	public abstract void deleteReply(Map guestBookInfo) throws SQLException;
	
	public abstract void updateReply(GuestBookDTO gdto) throws SQLException;
	
	public abstract StudentDTO selectStudentInfo(String studentId) throws SQLException;
}